Tabela Exam

Definicja tabeli Exam

Name

Exam

Code

Exam

Comment

 


Lista kolumn tabeli Exam

Name

Code

ID

ID

ExtID

ExtID

PatID

PatID

HospID

HospID

ServiceID

ServiceID

RefDeptID

RefDeptID

RefDrID

RefDrID

DescrDrID

DescrDrID

Status

Status

PublishStatus

PublishStatus

RefDate

RefDate

SubTypeID

SubTypeID

Diagnosis

Diagnosis

Descr

Descr

RadCode1

RadCode1

RadCode2

RadCode2

RadCode3

RadCode3

Remarks

Remarks

PerfDate

PerfDate

PatAgeInDays

PatAgeInDays

OwnerID

OwnerID

UpdUserID

UpdUserID

UpdNr

UpdNr

UpdDate

UpdDate

UpdTime

UpdTime

LockUserID

LockUserID

LockTime

LockTime

FullAcc

FullAcc

ReadAcc

ReadAcc

PRIORYTETID

PRIORYTETID

SKIERID

SKIERID

PerfDeptID

PerfDeptID

PerfExtID

PerfExtID

Comments

Comments

ExamRecordTypeID

ExamRecordTypeID

AccNum

AccNum


Kolumna ID tabeli Exam

Definicja kolumny ID tabeli Exam

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExtID tabeli Exam

Definicja kolumny ExtID tabeli Exam

Name

ExtID

Code

ExtID

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna PatID tabeli Exam

Definicja kolumny PatID tabeli Exam

Name

PatID

Code

PatID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HospID tabeli Exam

Definicja kolumny HospID tabeli Exam

Name

HospID

Code

HospID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ServiceID tabeli Exam

Definicja kolumny ServiceID tabeli Exam

Name

ServiceID

Code

ServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna RefDeptID tabeli Exam

Definicja kolumny RefDeptID tabeli Exam

Name

RefDeptID

Code

RefDeptID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna RefDrID tabeli Exam

Definicja kolumny RefDrID tabeli Exam

Name

RefDrID

Code

RefDrID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DescrDrID tabeli Exam

Definicja kolumny DescrDrID tabeli Exam

Name

DescrDrID

Code

DescrDrID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Status tabeli Exam

Definicja kolumny Status tabeli Exam

Name

Status

Code

Status

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PublishStatus tabeli Exam

Definicja kolumny PublishStatus tabeli Exam

Name

PublishStatus

Code

PublishStatus

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna RefDate tabeli Exam

Definicja kolumny RefDate tabeli Exam

Name

RefDate

Code

RefDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SubTypeID tabeli Exam

Definicja kolumny SubTypeID tabeli Exam

Name

SubTypeID

Code

SubTypeID

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Diagnosis tabeli Exam

Definicja kolumny Diagnosis tabeli Exam

Name

Diagnosis

Code

Diagnosis

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna Descr tabeli Exam

Definicja kolumny Descr tabeli Exam

Name

Descr

Code

Descr

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna RadCode1 tabeli Exam

Definicja kolumny RadCode1 tabeli Exam

Name

RadCode1

Code

RadCode1

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna RadCode2 tabeli Exam

Definicja kolumny RadCode2 tabeli Exam

Name

RadCode2

Code

RadCode2

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna RadCode3 tabeli Exam

Definicja kolumny RadCode3 tabeli Exam

Name

RadCode3

Code

RadCode3

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna Remarks tabeli Exam

Definicja kolumny Remarks tabeli Exam

Name

Remarks

Code

Remarks

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna PerfDate tabeli Exam

Definicja kolumny PerfDate tabeli Exam

Name

PerfDate

Code

PerfDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PatAgeInDays tabeli Exam

Definicja kolumny PatAgeInDays tabeli Exam

Name

PatAgeInDays

Code

PatAgeInDays

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OwnerID tabeli Exam

Definicja kolumny OwnerID tabeli Exam

Name

OwnerID

Code

OwnerID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UpdUserID tabeli Exam

Definicja kolumny UpdUserID tabeli Exam

Name

UpdUserID

Code

UpdUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdNr tabeli Exam

Definicja kolumny UpdNr tabeli Exam

Name

UpdNr

Code

UpdNr

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdDate tabeli Exam

Definicja kolumny UpdDate tabeli Exam

Name

UpdDate

Code

UpdDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna UpdTime tabeli Exam

Definicja kolumny UpdTime tabeli Exam

Name

UpdTime

Code

UpdTime

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LockUserID tabeli Exam

Definicja kolumny LockUserID tabeli Exam

Name

LockUserID

Code

LockUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LockTime tabeli Exam

Definicja kolumny LockTime tabeli Exam

Name

LockTime

Code

LockTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FullAcc tabeli Exam

Definicja kolumny FullAcc tabeli Exam

Name

FullAcc

Code

FullAcc

Data Type

RAW(255)

Mandatory

No

Comment

 


Kolumna ReadAcc tabeli Exam

Definicja kolumny ReadAcc tabeli Exam

Name

ReadAcc

Code

ReadAcc

Data Type

RAW(255)

Mandatory

No

Comment

 


Kolumna PRIORYTETID tabeli Exam

Definicja kolumny PRIORYTETID tabeli Exam

Name

PRIORYTETID

Code

PRIORYTETID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SKIERID tabeli Exam

Definicja kolumny SKIERID tabeli Exam

Name

SKIERID

Code

SKIERID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfDeptID tabeli Exam

Definicja kolumny PerfDeptID tabeli Exam

Name

PerfDeptID

Code

PerfDeptID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfExtID tabeli Exam

Definicja kolumny PerfExtID tabeli Exam

Name

PerfExtID

Code

PerfExtID

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna Comments tabeli Exam

Definicja kolumny Comments tabeli Exam

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ExamRecordTypeID tabeli Exam

Definicja kolumny ExamRecordTypeID tabeli Exam

Name

ExamRecordTypeID

Code

ExamRecordTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AccNum tabeli Exam

Definicja kolumny AccNum tabeli Exam

Name

AccNum

Code

AccNum

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Lista kluczy tabeli Exam

Name

Code

Primary

PK_EXAM

PK_EXAM

X


Klucz PK_EXAM tabeli Exam

Definicja klucza PK_EXAM tabeli Exam

Name

PK_EXAM

Code

PK_EXAM

Primary

Yes

Comment